Convert a table to a regular range

To convert a table to a regular range with data, follow these steps:

1.Select the table cell or range of cells.

2.Run the conversion command in one of the following ways:

On the Home tab, in the Table group, click t_convert_smart_table Convert.

When working in macOS, select the Data > Convert into regular range command from the command menu.

Open the context menu by right-clicking and run the Convert into regular range command.

3.In the Table window that opens, click Convert.

info

When converting a table to a regular range, the autofilters in the table headers will be removed and any rows/columns hidden by grouping will be displayed.

 

© New Cloud Technologies Ltd., 2013—2025
MyOffice Spreadsheet 3.5E